Re: [GENERAL] Fast join

At 18:33 +0300 on 29/06/1999, Leon wrote:


> adb=>  EXPLAIN  SELECT COUNT(*) FROM atable WHERE atable.cfield =
>btable.cfield
> AND atable.afield<10;
...
>
> adb=>  EXPLAIN  SELECT COUNT(*) FROM atable WHERE atable.cfield =
>btable.cfield
> AND atable.afield>100;

Hey, shouldn't these be:

SELECT COUNT(*)
FROM atable, btable  <----- Note this!
WHERE atable.cfield = btable.cfield
AND ....

I'm not sure that when the other table is implicit, the optimizer checks
the statistics of the btable on time.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma